/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.oa.action.humanresources;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.oa.mapper.humanresources.InterviewMapper;
public class InterviewAction extends BaseAction
{
    @Autowired(required=false)
	private InterviewMapper mapper;
    /**
    预约统计
    */
    
    public Map bespeakCount() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_year=mapper.s_year(params);
        s_year.setSelectNone("年");
        result.put("s_year", s_year);
        
        
        SQLList<SQLMap> s_month=mapper.s_month(params);
        s_month.setSelectNone("月");
        result.put("s_month", s_month);
        
        
        params.def("CMIDSEL1",SQL.getYear());
        Object CMIDSEL1 =mapper.CMIDSEL1(params);
        result.put("CMIDSEL1", CMIDSEL1);
        
        
        params.def("CMIDSEL2",SQL.getMonth());
        Object CMIDSEL2 =mapper.CMIDSEL2(params);
        result.put("CMIDSEL2", CMIDSEL2);
        
        
        SQLList<SQLMap> s_calendar=mapper.s_calendar(params);
        result.put("s_calendar", s_calendar);
        
        return result;
    }
    /**
    面试统计
    */
    
    public Map interviewCount() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_year=mapper.s_year(params);
        s_year.setSelectNone("年");
        result.put("s_year", s_year);
        
        
        SQLList<SQLMap> s_month=mapper.s_month(params);
        s_month.setSelectNone("月");
        result.put("s_month", s_month);
        
        
        params.def("CMIDSEL1",SQL.getYear());
        Object CMIDSEL1 =mapper.CMIDSEL1(params);
        result.put("CMIDSEL1", CMIDSEL1);
        
        
        params.def("CMIDSEL2",SQL.getMonth());
        Object CMIDSEL2 =mapper.CMIDSEL2(params);
        result.put("CMIDSEL2", CMIDSEL2);
        
        
        SQLList<SQLMap> s_calendar=mapper.s_calendar(params);
        result.put("s_calendar", s_calendar);
        
        return result;
    }
    /**
    岗位员工需求管理
    */
    
    public Map stationDemandAdmin() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_role=mapper.s_role(params);
        result.put("s_role", s_role);
        
        return result;
    }
    /**
    查看岗位员工审批情况
    */
    
    public Map stationApproval() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_mydemands=mapper.s_mydemands(params,pagination);
        s_mydemands.setPagedListInfo(pagination);
        result.put("s_mydemands", s_mydemands);
        
        return result;
    }
    /**
    审核意见
    */
    
    public Map examinelOpinion() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_check_des=mapper.s_check_des(params);
        SQLMap s_check_des_emt=s_check_des.getExistfirst();
        result.put("s_check_des", s_check_des_emt);
        
        return result;
    }
    /**
    批准意见
    */
    
    public Map approvalOpinion() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_allow_des=mapper.s_allow_des(params);
        SQLMap s_allow_des_emt=s_allow_des.getExistfirst();
        result.put("s_allow_des", s_allow_des_emt);
        
        return result;
    }
    /**
    岗位员工需求列表
    */
    
    public Map staffDemand() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_hire=mapper.s_hire(params);
        result.put("s_hire", s_hire);
        
        return result;
    }
    /**
    招聘信息发布
    */
    
    public Map recruitInfoRelease() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_hire=mapper.s_hire(params);
        result.put("s_hire", s_hire);
        
        return result;
    }
    /**
    岗位职责
    */
    
    public Map stationDuty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        
        SQLList<SQLMap> s_jobduty=mapper.s_jobduty(params);
        result.put("s_jobduty", s_jobduty);
        
        
        SQLList<SQLMap> s_check=mapper.s_check(params);
        result.put("s_check", s_check);
        
        
        SQLList<SQLMap> s_audition=mapper.s_audition(params);
        result.put("s_audition", s_audition);
        
        return result;
    }
    /**
    招聘标题
    */
    
    public Map recruitTitle() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_hire=mapper.s_hire(params);
        SQLMap s_hire_emt=s_hire.getExistfirst();
        result.put("s_hire", s_hire_emt);
        
        return result;
    }
    /**
    应聘人员填写页面
    */
    
    public Map recruitWrite() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_1=mapper.s_1(params);
        result.put("s_1", s_1);
        
        
        SQLList<SQLMap> l_pf=mapper.l_pf(params);
        result.put("l_pf", l_pf);
        
        
        SQLList<SQLMap> l_pt=mapper.l_pt(params);
        result.put("l_pt", l_pt);
        
        
        SQLList<SQLMap> l_station=mapper.l_station(params);
        result.put("l_station", l_station);
        
        return result;
    }
    /**
    明细页面
    */
    
    public Map applyDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> l_pf=mapper.l_pf(params);
        result.put("l_pf", l_pf);
        
        
        SQLList<SQLMap> l_pt=mapper.l_pt(params);
        result.put("l_pt", l_pt);
        
        
        SQLList<SQLMap> l_station=mapper.l_station(params);
        result.put("l_station", l_station);
        
        
        SQLList<SQLMap> s_person=mapper.s_person(params);
        SQLMap s_person_emt=s_person.getExistfirst();
        result.put("s_person", s_person_emt);
        
        
        SQLList<SQLMap> s_level=mapper.s_level(params);
        result.put("s_level", s_level);
        
        
        SQLList<SQLMap> s_wkundergo=mapper.s_wkundergo(params);
        result.put("s_wkundergo", s_wkundergo);
        
        
        SQLList<SQLMap> s_skill=mapper.s_skill(params);
        SQLMap s_skill_emt=s_skill.getExistfirst();
        result.put("s_skill", s_skill_emt);
        
        
        SQLList<SQLMap> s_relation=mapper.s_relation(params);
        result.put("s_relation", s_relation);
        
        
        SQLList<SQLMap> s_mem=mapper.s_mem(params);
        result.put("s_mem", s_mem);
        
        
        
        return result;
    }
    /**
    修改页面
    */
    
    public Map applyUp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> l_pf=mapper.l_pf(params);
        result.put("l_pf", l_pf);
        
        
        SQLList<SQLMap> l_pt=mapper.l_pt(params);
        result.put("l_pt", l_pt);
        
        
        SQLList<SQLMap> l_station=mapper.l_station(params);
        result.put("l_station", l_station);
        
        
        
        
        SQLList<SQLMap> s_person=mapper.s_person(params);
        SQLMap s_person_emt=s_person.getExistfirst();
        result.put("s_person", s_person_emt);
        
        
        SQLList<SQLMap> s_level=mapper.s_level(params);
        result.put("s_level", s_level);
        
        
        SQLList<SQLMap> s_wkundergo=mapper.s_wkundergo(params);
        result.put("s_wkundergo", s_wkundergo);
        
        
        SQLList<SQLMap> s_skill=mapper.s_skill(params);
        SQLMap s_skill_emt=s_skill.getExistfirst();
        result.put("s_skill", s_skill_emt);
        
        
        SQLList<SQLMap> s_relation=mapper.s_relation(params);
        result.put("s_relation", s_relation);
        
        
        SQLList<SQLMap> s_mem=mapper.s_mem(params);
        result.put("s_mem", s_mem);
        
        
        
        return result;
    }
    /**
    人才库
    */
    
    public Map personnelResources() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_p=mapper.s_p(params);
        result.put("s_p", s_p);
        
        return result;
    }
    /**
    面试人员列表
    */
    
    public Map interviewWrite() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_int=mapper.s_int(params,pagination);
        s_int.setPagedListInfo(pagination);
        result.put("s_int", s_int);
        
        return result;
    }
    /**
    明细页面
    */
    
    public Map interview_detail() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> l_pf=mapper.l_pf(params);
        result.put("l_pf", l_pf);
        
        
        SQLList<SQLMap> l_pt=mapper.l_pt(params);
        result.put("l_pt", l_pt);
        
        
        SQLList<SQLMap> l_station=mapper.l_station(params);
        result.put("l_station", l_station);
        
        
        SQLList<SQLMap> s_person=mapper.s_person(params);
        SQLMap s_person_emt=s_person.getExistfirst();
        result.put("s_person", s_person_emt);
        
        
        SQLList<SQLMap> s_level=mapper.s_level(params);
        result.put("s_level", s_level);
        
        
        SQLList<SQLMap> s_wkundergo=mapper.s_wkundergo(params);
        result.put("s_wkundergo", s_wkundergo);
        
        
        SQLList<SQLMap> s_skill=mapper.s_skill(params);
        SQLMap s_skill_emt=s_skill.getExistfirst();
        result.put("s_skill", s_skill_emt);
        
        
        SQLList<SQLMap> s_relation=mapper.s_relation(params);
        result.put("s_relation", s_relation);
        
        
        SQLList<SQLMap> s_mem=mapper.s_mem(params);
        result.put("s_mem", s_mem);
        
        
        
        return result;
    }
    /**
    通知面试
    */
    
    public Map noticeInterview() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_person=mapper.s_person(params);
        SQLMap s_person_emt=s_person.getExistfirst();
        result.put("s_person", s_person_emt);
        
        return result;
    }
    /**
    岗位员工需求管理修改
    */
    
    public Map stationDemandAdminSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID1 = mapper.CMID1(params);
        result.put("CMID1", CMID1);
        
        return result;
    }
    /**
    */
    
    public Map d_hire() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_hire(params);
        
        return result;
    }
    /**
    */
    
    public Map u_unonline() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.u_unonline(params);
        
        return result;
    }
    /**
    招聘标题修改
    */
    
    public Map recruitTitleSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.recruitTitleSubmit(params);
        
        return result;
    }
    /**
    应聘人员填写页面修改
    */
    
    public Map recruitWriteSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID = mapper.CMID(params);
        result.put("CMID", CMID);
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_level")){
            params=new SQLParam(request,emt.getMap());
            mapper.bi_level(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_wkundergo")){
            params=new SQLParam(request,emt.getMap());
            mapper.bi_wkundergo(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_familymem")){
            params=new SQLParam(request,emt.getMap());
            mapper.bi_familymem(params);
        }
        
        
        int i_skill = mapper.i_skill(params);
        result.put("i_skill", i_skill);
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_relation")){
            params=new SQLParam(request,emt.getMap());
            mapper.bi_relation(params);
        }
        
        return result;
    }
    /**
    修改页面修改
    */
    
    public Map applyUpSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_person = mapper.u_person(params);
        result.put("u_person", u_person);
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_level")){
            params=new SQLParam(request,emt.getMap());
            mapper.u_level(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_wkundergo")){
            params=new SQLParam(request,emt.getMap());
            mapper.u_wkundergo(params);
        }
        
        
        int u_skill = mapper.u_skill(params);
        result.put("u_skill", u_skill);
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_relation")){
            params=new SQLParam(request,emt.getMap());
            mapper.u_relation(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("per_familymem")){
            params=new SQLParam(request,emt.getMap());
            mapper.u_mem(params);
        }
        
        return result;
    }
    /**
    */
    
    public Map eu_person() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.eu_person(params);
        
        return result;
    }
    /**
    */
    
    public Map u_person() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.u_person(params);
        
        return result;
    }
    /**
    */
    
    public Map eu_personn() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.eu_personn(params);
        
        return result;
    }
    /**
    */
    
    public Map eu_persony() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.eu_persony(params);
        
        return result;
    }
    /**
    通知面试修改
    */
    
    public Map noticeInterviewSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_person = mapper.u_person(params);
        result.put("u_person", u_person);
        
        return result;
    }
}